CREATE VIEW [dbo].[vUserDefinedCustomerExperience]
AS
SELECT
    [dbo].[UserDefinedCustomerExperience].[UserDefinedCustomerExperienceKey],
    [dbo].[Program].[ProgramKey],
    [dbo].[UserDefinedCustomerExperience].[UserDefinedCustomerExperienceName],
    [dbo].[UserDefinedCustomerExperience].[UserDefinedCustomerExperienceDesc],
    [dbo].[UserDefinedCustomerExperience].[CompletionDate],
    [dbo].[UserDefinedCustomerExperience].[UserDefinedCustomerExperienceUnits],
    [dbo].[UserDefinedCustomerExperience].[UserDefinedCustomerExperienceLocation],
    [dbo].[Program].[ProgramName],
    [dbo].[Program].[UserDefinedExperiencesFlag],
    [dbo].[Program].[UomKey],
    [dbo].[Program].[MinimumValue],
    [dbo].[Program].[MaximumValue],
    [dbo].[Program].[ProgramDescr],
    [dbo].[Program].[ProgramStatusCode],
    [dbo].[Program].[RequiresApprovalFlag],
    CONVERT(BIT, 0) AS RequiresGradeFlag,
    '' AS Grade
FROM
    [dbo].[UserDefinedCustomerExperience]
        INNER JOIN [dbo].[Program] ON [dbo].[UserDefinedCustomerExperience].[ProgramKey] = [dbo].[Program].[ProgramKey]

GO